﻿CREATE PROCEDURE [dbo].[AddMarkCondition]
	@MarkConditionId uniqueidentifier,
    @Mark uniqueidentifier,
    @RequiredMark uniqueidentifier,
    @RequiredActivity uniqueidentifier,
    @CreatedBy uniqueidentifier,
    @IsDeleted bit,
	@CreatedOn datetime,
    @LastChanged datetime,
	@LastChangedBy uniqueidentifier,

	@TimeStamp timestamp output

AS

	INSERT INTO MarkCondition

	(MarkConditionId, Mark, RequiredMark, RequiredActivity, CreatedBy, IsDeleted, CreatedOn, LastChanged, LastChangedBy)

	VALUES 

	(@MarkConditionId, @Mark, @RequiredMark, @RequiredActivity, @CreatedBy, @IsDeleted, @CreatedOn, @LastChanged, @LastChangedBy)

	SELECT @TimeStamp = [TimeStamp]

	FROM MarkCondition WHERE MarkConditionId=@MarkConditionId

RETURN 0